explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qrDp

Settings
# exclusive inclusive rows x rows loops node
1. 140,350.705 200,788.063 ↓ 0.0 0 1

Insert on live_delivery (cost=0.42..1,525,774.08 rows=58,433,505 width=169) (actual time=200,788.063..200,788.063 rows=0 loops=1)

2. 21,067.045 60,437.358 ↑ 1.0 58,110,390 1

Nested Loop (cost=0.42..1,525,774.08 rows=58,433,505 width=169) (actual time=28.460..60,437.358 rows=58,110,390 loops=1)

3. 21,490.193 21,490.193 ↑ 1.0 298,002 1

Index Scan using idx_rate_card_type_code on demo_groups d (cost=0.42..64,936.46 rows=299,659 width=1,218) (actual time=28.442..21,490.193 rows=298,002 loops=1)

  • Index Cond: ((rate_card_type_code)::text = 'std'::text)
4. 17,880.120 17,880.120 ↑ 1.0 195 298,002

Values Scan on "*VALUES*" (cost=0.00..2.44 rows=195 width=64) (actual time=0.000..0.060 rows=195 loops=298,002)