explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I02q

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.009 1,450.193 ↑ 1.0 1 1

Limit (cost=19,856.54..19,856.55 rows=1 width=96) (actual time=1,450.188..1,450.193 rows=1 loops=1)

2. 0.132 1,450.184 ↑ 94.0 1 1

Sort (cost=19,856.54..19,856.78 rows=94 width=96) (actual time=1,450.184..1,450.184 rows=1 loops=1)

  • Sort Key: o.obstime DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 0.031 1,450.052 ↑ 8.5 11 1

Nested Loop (cost=155.47..19,856.07 rows=94 width=96) (actual time=260.324..1,450.052 rows=11 loops=1)

4. 0.073 0.073 ↑ 1.0 1 1

Index Scan using orbits_desig_pkd_key on orbits e (cost=0.42..8.44 rows=1 width=50) (actual time=0.069..0.073 rows=1 loops=1)

  • Index Cond: ((desig_pkd)::text = '000000015'::text)
5. 1,354.425 1,449.948 ↑ 132.7 11 1

Bitmap Heap Scan on obs o (cost=155.05..19,833.03 rows=1,460 width=66) (actual time=260.242..1,449.948 rows=11 loops=1)

  • Recheck Cond: ((provid_pkd = (e.desig_pkd)::text) OR (permid_pkd = (e.desig_pkd)::text))
  • Filter: ((obstime > (e.last_obs_used)::text) AND ((status = 'p'::bpchar) OR (status = 'P'::bpchar)))
  • Rows Removed by Filter: 2667
  • Heap Blocks: exact=475
6. 0.005 95.523 ↓ 0.0 0 1

BitmapOr (cost=155.05..155.05 rows=4,957 width=0) (actual time=95.523..95.523 rows=0 loops=1)

7. 0.036 0.036 ↓ 0.0 0 1

Bitmap Index Scan on obs_provid_pkd_key (cost=0.00..54.15 rows=1,811 width=0) (actual time=0.036..0.036 rows=0 loops=1)

  • Index Cond: (provid_pkd = (e.desig_pkd)::text)
8. 95.482 95.482 ↑ 1.2 2,686 1

Bitmap Index Scan on obs_permid_pkd_key (cost=0.00..100.16 rows=3,146 width=0) (actual time=95.482..95.482 rows=2,686 loops=1)

  • Index Cond: (permid_pkd = (e.desig_pkd)::text)