explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kw1O

Settings
# exclusive inclusive rows x rows loops node
1. 0.181 3.994 ↑ 1.0 100 1

Limit (cost=0.00..46,522,549.68 rows=100 width=14) (actual time=0.015..3.994 rows=100 loops=1)

2. 0.309 3.813 ↑ 3,757.8 100 1

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

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

SubPlan (for Seq Scan)

4. 0.096 1.728 ↑ 1.0 1 24

Aggregate (cost=223,668.78..223,668.79 rows=1 width=8) (actual time=0.071..0.072 rows=1 loops=24)

5. 0.127 1.632 ↑ 128,460.0 1 24

Nested Loop (cost=12,641.44..223,347.63 rows=128,460 width=8) (actual time=0.055..0.068 rows=1 loops=24)

6. 0.120 0.792 ↑ 1.0 1 24

HashAggregate (cost=12,640.86..12,640.87 rows=1 width=7) (actual time=0.032..0.033 rows=1 loops=24)

  • Group Key: internal.lgr_ticket
7. 0.072 0.672 ↑ 1.0 1 24

Limit (cost=0.57..12,640.85 rows=1 width=7) (actual time=0.027..0.028 rows=1 loops=24)

8. 0.600 0.600 ↑ 1.0 1 24

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.025..0.025 rows=1 loops=24)

  • 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: 8
9. 0.713 0.713 ↑ 919.0 1 23

Index Scan using idx_lgr_ticket on uat_log_revalidation external (cost=0.57..210,697.56 rows=919 width=15) (actual time=0.019..0.031 rows=1 loops=23)

  • Index Cond: (lgr_ticket = internal.lgr_ticket)
  • Filter: (lgr_action_ticket IS NOT NULL)
  • Rows Removed by Filter: 35
10. 0.072 1.776 ↑ 1.0 1 24

Aggregate (cost=241,556.59..241,556.60 rows=1 width=8) (actual time=0.073..0.074 rows=1 loops=24)

11. 0.128 1.704 ↓ 0.0 0 24

Nested Loop (cost=30,529.26..241,235.44 rows=128,460 width=8) (actual time=0.071..0.071 rows=0 loops=24)

12. 0.120 0.840 ↑ 1.0 1 24

HashAggregate (cost=30,528.68..30,528.69 rows=1 width=7) (actual time=0.034..0.035 rows=1 loops=24)

  • Group Key: internal_1.lgr_ticket
13. 0.072 0.720 ↑ 1.0 1 24

Limit (cost=0.57..30,528.67 rows=1 width=7) (actual time=0.029..0.030 rows=1 loops=24)

14. 0.648 0.648 ↑ 2.0 1 24

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.027..0.027 rows=1 loops=24)

  • 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: 14
15. 0.736 0.736 ↓ 0.0 0 23

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.032..0.032 rows=0 loops=23)

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