explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kepw

Settings
# exclusive inclusive rows x rows loops node
1. 1.828 350.833 ↑ 1.0 1,000 1

Limit (cost=0.00..465,225,496.75 rows=1,000 width=14) (actual time=0.015..350.833 rows=1,000 loops=1)

2. 4.412 349.005 ↑ 375.8 1,000 1

Seq Scan on uat_device (cost=0.00..174,820,111,042.86 rows=375,775 width=14) (actual time=0.013..349.005 rows=1,000 loops=1)

  • Filter: (dvc_role <> ALL ('{1,3,4,5,7}'::numeric[]))
  • Rows Removed by Filter: 1
3.          

SubPlan (for Seq Scan)

4. 2.036 27.486 ↑ 1.0 1 509

Aggregate (cost=223,668.78..223,668.79 rows=1 width=8) (actual time=0.053..0.054 rows=1 loops=509)

5. 2.283 25.450 ↓ 0.0 0 509

Nested Loop (cost=12,641.44..223,347.63 rows=128,460 width=8) (actual time=0.047..0.050 rows=0 loops=509)

6. 2.036 13.234 ↑ 1.0 1 509

HashAggregate (cost=12,640.86..12,640.87 rows=1 width=7) (actual time=0.025..0.026 rows=1 loops=509)

  • Group Key: internal.lgr_ticket
7. 2.036 11.198 ↑ 1.0 1 509

Limit (cost=0.57..12,640.85 rows=1 width=7) (actual time=0.021..0.022 rows=1 loops=509)

8. 9.162 9.162 ↑ 1.0 1 509

Index Scan using idx_lgr_rev_svcid_dvcid on uat_log_revalidation internal (cost=0.57..12,640.85 rows=1 width=7) (actual time=0.018..0.018 rows=1 loops=509)

  • Index Cond: ((lgr_dvcid = uat_device.dvc_id) AND (lgr_rev_svcid = '52'::numeric))
  • Filter: ((uat_device.dvc_cbn = lgr_date) AND ((lgr_action)::text = 'Starting Revalidation'::text))
  • Rows Removed by Filter: 5
9. 9.933 9.933 ↓ 0.0 0 473

Index Scan using idx_lgr_ticket on uat_log_revalidation external (cost=0.57..210,697.56 rows=919 width=15) (actual time=0.017..0.021 rows=0 loops=473)

  • Index Cond: (lgr_ticket = internal.lgr_ticket)
  • Filter: (lgr_action_ticket IS NOT NULL)
  • Rows Removed by Filter: 26
10. 4.072 317.107 ↑ 1.0 1 509

Aggregate (cost=241,556.59..241,556.60 rows=1 width=8) (actual time=0.622..0.623 rows=1 loops=509)

11. 7.272 313.035 ↑ 25,692.0 5 509

Nested Loop (cost=30,529.26..241,235.44 rows=128,460 width=8) (actual time=0.209..0.615 rows=5 loops=509)

12. 2.036 15.270 ↑ 1.0 1 509

HashAggregate (cost=30,528.68..30,528.69 rows=1 width=7) (actual time=0.029..0.030 rows=1 loops=509)

  • Group Key: internal_1.lgr_ticket
13. 2.036 13.234 ↑ 1.0 1 509

Limit (cost=0.57..30,528.67 rows=1 width=7) (actual time=0.025..0.026 rows=1 loops=509)

14. 11.198 11.198 ↑ 2.0 1 509

Index Scan using idx_lgr_rev_svcid_dvcid on uat_log_revalidation internal_1 (cost=0.57..61,056.76 rows=2 width=7) (actual time=0.022..0.022 rows=1 loops=509)

  • Index Cond: ((lgr_dvcid = uat_device.dvc_id) AND (lgr_rev_svcid = '53'::numeric))
  • Filter: ((uat_device.dvc_priv = lgr_date) AND ((lgr_action)::text = 'Starting Revalidation'::text))
  • Rows Removed by Filter: 7
15. 290.493 290.493 ↑ 153.2 6 477

Index Scan using idx_lgr_ticket on uat_log_revalidation external_1 (cost=0.57..210,697.56 rows=919 width=15) (actual time=0.187..0.609 rows=6 loops=477)

  • Index Cond: (lgr_ticket = internal_1.lgr_ticket)
  • Filter: (lgr_action_ticket IS NOT NULL)
  • Rows Removed by Filter: 1586