explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K1W4

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 2,590.527 ↑ 1.0 5 1

Limit (cost=0.45..8,032.12 rows=5 width=4) (actual time=8.522..2,590.527 rows=5 loops=1)

2. 0.868 2,590.522 ↑ 2.2 5 1

Unique (cost=0.45..17,670.11 rows=11 width=4) (actual time=8.520..2,590.522 rows=5 loops=1)

3. 1,596.192 2,589.654 ↓ 263.2 2,895 1

Nested Loop (cost=0.45..17,670.09 rows=11 width=4) (actual time=8.518..2,589.654 rows=2,895 loops=1)

  • Join Filter: (z.group_id = zp.zaiko_group_id)
  • Rows Removed by Join Filter: 14637583
4. 1.019 11.904 ↓ 146.0 3,942 1

Merge Append (cost=0.45..11,083.24 rows=27 width=8) (actual time=0.024..11.904 rows=3,942 loops=1)

  • Sort Key: z.auction_date
5. 0.004 0.006 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=1)

  • Sort Key: z.auction_date
  • Sort Method: quicksort Memory: 25kB
6. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on zaiko z (cost=0.00..0.00 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((id = orgid) AND (auction_date > date_trunc('day'::text, now())))
7. 10.879 10.879 ↓ 151.6 3,942 1

Index Scan using zaiko_auction_date_idx on zaiko z_1 (cost=0.43..11,083.01 rows=26 width=8) (actual time=0.018..10.879 rows=3,942 loops=1)

  • Index Cond: (auction_date > date_trunc('day'::text, now()))
  • Filter: (id = orgid)
  • Rows Removed by Filter: 1493
8. 975.138 981.558 ↓ 2.0 3,714 3,942

Materialize (cost=0.00..5,830.95 rows=1,878 width=4) (actual time=0.000..0.249 rows=3,714 loops=3,942)

9. 0.438 6.420 ↓ 2.0 3,714 1

Append (cost=0.00..5,821.56 rows=1,878 width=4) (actual time=1.198..6.420 rows=3,714 loops=1)

10. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on zaiko_publish zp (cost=0.00..0.00 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (customer_id = 32)
11. 5.354 5.980 ↓ 2.0 3,714 1

Bitmap Heap Scan on zaiko_publish zp_1 (cost=38.98..5,821.56 rows=1,877 width=4) (actual time=1.195..5.980 rows=3,714 loops=1)

  • Recheck Cond: (customer_id = 32)
  • Heap Blocks: exact=3671
12. 0.626 0.626 ↓ 2.0 3,714 1

Bitmap Index Scan on zaiko_publish_customer_id_idx (cost=0.00..38.51 rows=1,877 width=0) (actual time=0.626..0.626 rows=3,714 loops=1)

  • Index Cond: (customer_id = 32)