explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o7JK

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 396.919 ↑ 1.0 20 1

Limit (cost=4.43..59,894.70 rows=20 width=302) (actual time=35.512..396.919 rows=20 loops=1)

2. 0.050 396.907 ↑ 6,400.1 20 1

Nested Loop Left Join (cost=4.43..383,303,702.55 rows=128,002 width=302) (actual time=35.510..396.907 rows=20 loops=1)

3. 0.057 394.557 ↑ 6,400.1 20 1

Nested Loop Left Join (cost=4.14..383,008,695.90 rows=128,002 width=274) (actual time=35.484..394.557 rows=20 loops=1)

4. 0.058 385.700 ↑ 6,400.1 20 1

Nested Loop Left Join (cost=3.71..382,695,478.49 rows=128,002 width=249) (actual time=34.475..385.700 rows=20 loops=1)

5. 0.039 379.062 ↑ 6,400.1 20 1

Nested Loop Left Join (cost=3.27..382,382,261.17 rows=128,002 width=222) (actual time=33.037..379.062 rows=20 loops=1)

6. 0.053 370.263 ↑ 6,400.1 20 1

Nested Loop (cost=2.84..382,070,003.17 rows=128,002 width=159) (actual time=30.980..370.263 rows=20 loops=1)

7. 0.412 369.030 ↑ 6,400.1 20 1

Nested Loop (cost=2.40..381,757,744.18 rows=128,002 width=4) (actual time=30.950..369.030 rows=20 loops=1)

  • Join Filter: (scenario_run.scenario_id = scenario.scenario_id)
  • Rows Removed by Join Filter: 3,029
8. 2.320 365.569 ↑ 25,818.8 3,049 1

Nested Loop (cost=2.13..380,576,918.94 rows=78,721,529 width=8) (actual time=0.062..365.569 rows=3,049 loops=1)

9. 0.775 171.162 ↑ 25,818.8 3,049 1

Nested Loop (cost=1.69..188,332,678.26 rows=78,721,529 width=8) (actual time=0.053..171.162 rows=3,049 loops=1)

10. 65.890 147.725 ↑ 26,267.4 1,259 1

Nested Loop (cost=1.12..95,934,254.82 rows=33,070,640 width=8) (actual time=0.040..147.725 rows=1,259 loops=1)

  • -> Index Scan Backward using ix_client_message_dialog_id_serial_number on client_message (cost=0.56..16353426.66 rows=30,998,652 width=8) (actual time=0.022..64.493 rows=1,259 loops
11. 81.835 81.835 ↑ 1.0 1 1,259

Index Scan using uq_step_source_client_message_id on step_source (cost=0.56..2.57 rows=1 width=8) (actual time=0.065..0.065 rows=1 loops=1,259)

  • Index Cond: (client_message_id = client_message.client_message_id)
12. 22.662 22.662 ↑ 3.5 2 1,259

Index Scan using ix_step_step_source_id on step (cost=0.57..2.72 rows=7 width=8) (actual time=0.013..0.018 rows=2 loops=1,259)

  • Index Cond: (step_source_id = step_source.step_source_id)
13. 192.087 192.087 ↑ 1.0 1 3,049

Index Scan using pk_scenario_run on scenario_run (cost=0.44..2.44 rows=1 width=8) (actual time=0.063..0.063 rows=1 loops=3,049)

  • Index Cond: (scenario_run_id = step.run_id)
14. 0.900 3.049 ↑ 1.0 1 3,049

Materialize (cost=0.28..2.30 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=3,049)

15. 2.149 2.149 ↑ 1.0 1 1

Index Scan using uq_scenario_type on scenario (cost=0.28..2.29 rows=1 width=4) (actual time=2.148..2.149 rows=1 loops=1)

  • Index Cond: ((type = 'TCRM'::text) AND (name = 'what_can_assistant_do_chatbot_vas'::text))
16. 1.180 1.180 ↑ 1.0 1 20

Index Scan using pk_dialog on dialog (cost=0.43..2.44 rows=1 width=159) (actual time=0.059..0.059 rows=1 loops=20)

  • Index Cond: (dialog_id = client_message.dialog_id)
17. 8.760 8.760 ↑ 1.0 1 20

Index Scan using pk_user on "user" user_1 (cost=0.43..2.44 rows=1 width=63) (actual time=0.438..0.438 rows=1 loops=20)

  • Index Cond: (user_id = dialog.user_id)
18. 6.580 6.580 ↑ 1.0 1 20

Index Scan using ix_siebel_user_user_id on siebel_user siebel_user_1 (cost=0.43..2.44 rows=1 width=27) (actual time=0.329..0.329 rows=1 loops=20)

  • Index Cond: (user_1.user_id = user_id)
19. 8.800 8.800 ↑ 1.0 1 20

Index Scan using ix_portal_user_user_id on portal_user portal_user_1 (cost=0.43..2.44 rows=1 width=25) (actual time=0.440..0.440 rows=1 loops=20)

  • Index Cond: (user_1.user_id = user_id)
20. 2.300 2.300 ↓ 0.0 0 20

Index Scan using ix_tmobile_user_user_id on tmobile_user tmobile_user_1 (cost=0.29..2.29 rows=1 width=28) (actual time=0.115..0.115 rows=0 loops=20)

  • Index Cond: (user_1.user_id = user_id)
Planning time : 20.113 ms
Execution time : 397.126 ms