explain.depesz.com

PostgreSQL's explain analyze made readable

Result: erSJ : synclog

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0 1 1

Limit (cost=0..0 rows=0 width=0) (actual rows=1 loops=1)

2. 0.000 0.000 ↓ 0.0 1 1

Sort (cost=0..0 rows=0 width=0) (actual rows=1 loops=1)

  • Sort Key: started DESC, id DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 0.000 0.000 ↓ 0.0 9,934 1

Bitmap Heap Scan on log log (cost=0..0 rows=0 width=0) (actual rows=9,934 loops=1)

  • Filter: (((source)::text = 'IslpSyncer_item'::text) AND ((appname)::text = 'IslpSyncer'::text))
  • Heap Blocks: exact=42,712
4. 0.000 0.000 ↓ 0.0 53,184 1

Bitmap Index Scan on log_unitid_index (cost=0..0 rows=0 width=0) (actual rows=53,184 loops=1)

  • Index Cond: ((unitid)::text = '5906'::text)
Planning time : 44.384 ms
Execution time : 74,499.075 ms