explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jrf8

Settings
# exclusive inclusive rows x rows loops node
1. 1.842 355.085 ↑ 1.0 1,000 1

Limit (cost=0.00..465,168,303.22 rows=1,000 width=14) (actual time=0.021..355.085 rows=1,000 loops=1)

2. 4.460 353.243 ↑ 375.8 1,000 1

Seq Scan on uat_device (cost=0.00..174,798,619,143.70 rows=375,775 width=14) (actual time=0.018..353.243 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.653 29.203 ↑ 1.0 1 551

Aggregate (cost=223,640.18..223,640.19 rows=1 width=8) (actual time=0.052..0.053 rows=1 loops=551)

5. 3.024 27.550 ↓ 0.0 0 551

Nested Loop (cost=12,637.54..223,319.06 rows=128,446 width=8) (actual time=0.046..0.050 rows=0 loops=551)

6. 2.755 14.326 ↑ 1.0 1 551

HashAggregate (cost=12,636.97..12,636.98 rows=1 width=7) (actual time=0.025..0.026 rows=1 loops=551)

  • Group Key: internal.lgr_ticket
7. 1.653 11.571 ↑ 1.0 1 551

Limit (cost=0.57..12,636.96 rows=1 width=7) (actual time=0.020..0.021 rows=1 loops=551)

8. 9.918 9.918 ↑ 1.0 1 551

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

  • 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: 4
9. 10.200 10.200 ↓ 0.0 0 510

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

  • Index Cond: (lgr_ticket = internal.lgr_ticket)
  • Filter: (lgr_action_ticket IS NOT NULL)
  • Rows Removed by Filter: 25
10. 4.408 319.580 ↑ 1.0 1 551

Aggregate (cost=241,528.00..241,528.01 rows=1 width=8) (actual time=0.579..0.580 rows=1 loops=551)

11. 7.755 315.172 ↑ 25,689.2 5 551

Nested Loop (cost=30,525.36..241,206.88 rows=128,446 width=8) (actual time=0.194..0.572 rows=5 loops=551)

12. 2.755 15.979 ↑ 1.0 1 551

HashAggregate (cost=30,524.79..30,524.80 rows=1 width=7) (actual time=0.028..0.029 rows=1 loops=551)

  • Group Key: internal_1.lgr_ticket
13. 1.653 13.224 ↑ 1.0 1 551

Limit (cost=0.57..30,524.77 rows=1 width=7) (actual time=0.024..0.024 rows=1 loops=551)

14. 11.571 11.571 ↑ 2.0 1 551

Index Scan using idx_lgr_rev_svcid_dvcid on uat_log_revalidation internal_1 (cost=0.57..61,048.97 rows=2 width=7) (actual time=0.021..0.021 rows=1 loops=551)

  • 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. 291.438 291.438 ↑ 183.8 5 514

Index Scan using idx_lgr_ticket on uat_log_revalidation external_1 (cost=0.57..210,672.89 rows=919 width=15) (actual time=0.172..0.567 rows=5 loops=514)

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