explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fiUI

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.058 ↑ 1.0 1 1

Result (cost=74.43..74.44 rows=1 width=1) (actual time=0.058..0.058 rows=1 loops=1)

2.          

Initplan (forResult)

3. 0.001 0.057 ↓ 0.0 0 1

Unique (cost=74.43..74.44 rows=2 width=4) (actual time=0.057..0.057 rows=0 loops=1)

4. 0.046 0.056 ↓ 0.0 0 1

Sort (cost=74.43..74.43 rows=2 width=4) (actual time=0.056..0.056 rows=0 loops=1)

  • Sort Key: (1)
  • Sort Method: quicksort Memory: 25kB
5. 0.000 0.010 ↓ 0.0 0 1

Append (cost=23.64..74.42 rows=2 width=4) (actual time=0.010..0.010 rows=0 loops=1)

6. 0.002 0.008 ↓ 0.0 0 1

Subquery Scan on auction (cost=23.64..27.67 rows=1 width=4) (actual time=0.008..0.008 rows=0 loops=1)

7. 0.000 0.006 ↓ 0.0 0 1

Limit (cost=23.64..27.66 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

8. 0.000 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on ps_auction (cost=23.64..27.66 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((orgid = 1621) AND (status = 3) AND (actual_end_date >= '2016-01-01 00:00:00'::timestamp without time zone) AND (actual_end_date <= '2019-03-01 00:00:00'::timestamp without time zone))
9. 0.001 0.006 ↓ 0.0 0 1

BitmapAnd (cost=23.64..23.64 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=1)

10. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on "psauction_orgid$auctionid_ndx" (cost=0.00..4.38 rows=12 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (orgid = 1621)
11. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on "psauction_status$actualend_ndx" (cost=0.00..19.01 rows=538 width=0) (never executed)

  • Index Cond: ((status = 3) AND (actual_end_date >= '2016-01-01 00:00:00'::timestamp without time zone) AND (actual_end_date <= '2019-03-01 00:00:00'::timestamp without time zone))
12. 0.000 0.002 ↓ 0.0 0 1

Subquery Scan on auction_1 (cost=0.29..46.73 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1)

13. 0.000 0.002 ↓ 0.0 0 1

Limit (cost=0.29..46.72 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1)

14. 0.003 0.003 ↓ 0.0 0 1

Index Scan using "psauction_orgid$auctionid_ndx" on ps_auction ps_auction_1 (cost=0.29..46.72 rows=1 width=4) (actual time=0.002..0.003 rows=0 loops=1)

  • Index Cond: (orgid = 1621)
  • Filter: ((start_date >= '2016-01-01 00:00:00'::timestamp without time zone) AND (start_date <= '2019-03-01 00:00:00'::timestamp without time zone) AND (status = 1) AND (archived = 'N'::bpchar))