explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hx9S

Settings
# exclusive inclusive rows x rows loops node
1. 1.964 358.857 ↑ 1.0 1,000 1

Limit (cost=0.00..465,218,434.50 rows=1,000 width=14) (actual time=0.020..358.857 rows=1,000 loops=1)

2. 4.823 356.893 ↑ 375.8 1,000 1

Seq Scan on uat_device (cost=0.00..174,817,457,225.19 rows=375,775 width=14) (actual time=0.016..356.893 rows=1,000 loops=1)

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

SubPlan (for Seq Scan)

4. 1.635 28.885 ↑ 1.0 1 545

Aggregate (cost=223,665.24..223,665.25 rows=1 width=8) (actual time=0.053..0.053 rows=1 loops=545)

5. 3.000 27.250 ↓ 0.0 0 545

Nested Loop (cost=12,641.44..223,344.10 rows=128,457 width=8) (actual time=0.046..0.050 rows=0 loops=545)

6. 2.180 14.170 ↑ 1.0 1 545

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

  • Group Key: internal.lgr_ticket
7. 2.180 11.990 ↑ 1.0 1 545

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

8. 9.810 9.810 ↑ 1.0 1 545

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=545)

  • 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.080 10.080 ↓ 0.0 0 504

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

  • Index Cond: (lgr_ticket = internal.lgr_ticket)
  • Filter: (lgr_action_ticket IS NOT NULL)
  • Rows Removed by Filter: 25
10. 4.905 323.185 ↑ 1.0 1 545

Aggregate (cost=241,553.06..241,553.07 rows=1 width=8) (actual time=0.592..0.593 rows=1 loops=545)

11. 7.798 318.280 ↑ 25,691.4 5 545

Nested Loop (cost=30,529.26..241,231.92 rows=128,457 width=8) (actual time=0.203..0.584 rows=5 loops=545)

12. 2.180 16.350 ↑ 1.0 1 545

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

  • Group Key: internal_1.lgr_ticket
13. 2.180 14.170 ↑ 1.0 1 545

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

14. 11.990 11.990 ↑ 2.0 1 545

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=545)

  • 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. 294.132 294.132 ↑ 183.8 5 508

Index Scan using idx_lgr_ticket on uat_log_revalidation external_1 (cost=0.57..210,694.04 rows=919 width=15) (actual time=0.180..0.579 rows=5 loops=508)

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