search

AlexTatiyants / pev

Postgres Explain Visualizer
MIT License
2.77k stars 192 forks source link

Is this redshift compatible? #21

Open shri opened 8 years ago

AlexTatiyants commented 8 years ago

To be honest, I don't know. I've never seen a RedShift generated query plan.

snagireddy91 commented 7 years ago

Hey @AlexTatiyants awesome work.

This is an example Redshift query plan. Any tips on how I can make this work with Pev? Would really appreciate any help. 

XN Aggregate  (cost=60818.21..60818.21 rows=1 width=0)
  ->  XN Seq Scan on mktg_sizmek_conv_f_sess s  (cost=0.00..60793.74 rows=9785 width=0)
        Filter: ((date(winner_event_dt) = '2017-02-01'::date) AND (dw_suspected_bot_in = false) AND (winner_event_dt IS NOT NULL))
AlexTatiyants commented 7 years ago

hi @snagireddy91, handling this would probably require modifications to the Plan service, though I am curious what happens if you give a JSON version of this to pev as is.

shazeline commented 7 years ago

@AlexTatiyants can you recommend any tools for converting query plans to JSON (redshift or otherwise)?

Redshift doesn't support exporting plans as JSON and I don't know enough to translate a plan like @snagireddy91's above into JSON by hand.

AlexTatiyants commented 7 years ago

Unfortunately, I’m not aware of any tools that do this.

On July 23, 2017 at 9:34:56 PM, Shahid Chohan (notifications@github.com) wrote:

@AlexTatiyants https://github.com/alextatiyants can you recommend any tools for converting query plans to JSON (redshift or otherwise)?

Redshift doesn't support exporting plans as JSON and I don't know enough to translate a plan like @snagireddy91 https://github.com/snagireddy91's above into JSON by hand.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/AlexTatiyants/pev/issues/21#issuecomment-317317181, or mute the thread https://github.com/notifications/unsubscribe-auth/AAvQnkCJ-dAlkF-r9ZQAQCaixhuBeQbKks5sRB7ugaJpZM4KLYOA .