explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RgGC

Settings
# exclusive inclusive rows x rows loops node
1. 1.830 350.900 ↑ 1.0 1,000 1

Limit (cost=0.00..465,522,661.75 rows=1,000 width=14) (actual time=0.013..350.900 rows=1,000 loops=1)

2. 4.477 349.070 ↑ 375.8 1,000 1

Seq Scan on uat_device (cost=0.00..174,931,778,220.74 rows=375,775 width=14) (actual time=0.011..349.070 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. 1.527 26.468 ↑ 1.0 1 509

Aggregate (cost=223,817.36..223,817.37 rows=1 width=8) (actual time=0.051..0.052 rows=1 loops=509)

5. 2.756 24.941 ↓ 0.0 0 509

Nested Loop (cost=12,641.44..223,496.21 rows=128,460 width=8) (actual time=0.045..0.049 rows=0 loops=509)

6. 2.545 12.725 ↑ 1.0 1 509

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

  • Group Key: internal.lgr_ticket
7. 1.527 10.180 ↑ 1.0 1 509

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

8. 8.653 8.653 ↑ 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.017..0.017 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.460 9.460 ↓ 0.0 0 473

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

  • Index Cond: (lgr_ticket = internal.lgr_ticket)
  • Filter: (lgr_action_ticket > '0'::numeric)
  • Rows Removed by Filter: 26
10. 3.563 318.125 ↑ 1.0 1 509

Aggregate (cost=241,705.17..241,705.18 rows=1 width=8) (actual time=0.624..0.625 rows=1 loops=509)

11. 7.400 314.562 ↑ 25,692.0 5 509

Nested Loop (cost=30,529.26..241,384.02 rows=128,460 width=8) (actual time=0.210..0.618 rows=5 loops=509)

12. 2.545 14.761 ↑ 1.0 1 509

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

  • Group Key: internal_1.lgr_ticket
13. 1.527 12.216 ↑ 1.0 1 509

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

14. 10.689 10.689 ↑ 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.021..0.021 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. 292.401 292.401 ↑ 153.2 6 477

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

  • Index Cond: (lgr_ticket = internal_1.lgr_ticket)
  • Filter: (lgr_action_ticket > '0'::numeric)
  • Rows Removed by Filter: 1586