explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qY1b

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 2,470.303 ↓ 0.0 0 1

Limit (cost=138,080.59..189,418.79 rows=2 width=1,295) (actual time=2,470.303..2,470.303 rows=0 loops=1)

2.          

CTE s

3. 208.009 1,258.587 ↓ 0.0 0 1

Bitmap Heap Scan on ismv_exchange_logs iel (cost=8,065.70..138,080.16 rows=27,810 width=8) (actual time=1,258.587..1,258.587 rows=0 loops=1)

  • Recheck Cond: (type = 'Ismv::TransactionList::In'::text)
  • Filter: ((state = 1) AND (response_code = 1))
  • Rows Removed by Filter: 185589
  • Heap Blocks: exact=49947
4. 1,050.578 1,050.578 ↓ 1.0 188,966 1

Bitmap Index Scan on iop_exchange_logs_type (cost=0.00..8,058.75 rows=183,426 width=0) (actual time=1,050.578..1,050.578 rows=188,966 loops=1)

  • Index Cond: (type = 'Ismv::TransactionList::In'::text)
5. 1,290.113 2,470.297 ↓ 0.0 0 1

Nested Loop (cost=0.43..713,857,682.55 rows=27,810 width=1,295) (actual time=2,470.297..2,470.297 rows=0 loops=1)

  • Join Filter: (s.ismv_exchange_log_id = ield.ismv_exchange_log_id)
  • -> Index Scan using pk_ismv_exchange_logs_data on ismv_exchange_logs_data ield (cost=0.43..233685.07 rows=1140475 width=1287) (actual time=0.096..1019.004 rows=11
6. 1,180.184 1,180.184 ↓ 0.0 0 1,180,184

CTE Scan on s (cost=0.00..556.20 rows=27,810 width=8) (actual time=0.001..0.001 rows=0 loops=1,180,184)