explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zgX

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 88.493 ↑ 1.0 2 1

Append (cost=7,653.28..7,653.34 rows=2 width=8) (actual time=88.489..88.493 rows=2 loops=1)

2.          

CTE duplicity_nezpracovane

3. 0.000 88.484 ↓ 0.0 0 1

Nested Loop Semi Join (cost=2,022.11..5,315.26 rows=774 width=12) (actual time=88.484..88.484 rows=0 loops=1)

4. 8.988 20.749 ↓ 11.0 8,707 1

Bitmap Heap Scan on raw_pabk_transaction rpt (cost=2,021.55..2,966.67 rows=789 width=12) (actual time=12.417..20.749 rows=8,707 loops=1)

  • Recheck Cond: (imported_transaction_id IS NULL)
  • Filter: (processed IS FALSE)
  • Heap Blocks: exact=5065
5. 0.215 11.761 ↓ 0.0 0 1

BitmapAnd (cost=2,021.55..2,021.55 rows=789 width=0) (actual time=11.761..11.761 rows=0 loops=1)

6. 4.408 4.408 ↑ 4.2 19,997 1

Bitmap Index Scan on raw_pabk_transaction_processed_index (cost=0.00..992.45 rows=83,629 width=0) (actual time=4.408..4.408 rows=19,997 loops=1)

  • Index Cond: (processed = false)
7. 7.138 7.138 ↓ 1.3 111,390 1

Bitmap Index Scan on raw_pabk_transaction_imported_transaction_id_idx (cost=0.00..1,028.45 rows=83,629 width=0) (actual time=7.138..7.138 rows=111,390 loops=1)

  • Index Cond: (imported_transaction_id IS NULL)
8. 69.656 69.656 ↓ 0.0 0 8,707

Index Scan using index_raw_pabk_bank_tx_id on raw_pabk_transaction p (cost=0.56..2.97 rows=1 width=12) (actual time=0.008..0.008 rows=0 loops=8,707)

  • Index Cond: ((bank_tx_id)::text = (rpt.bank_tx_id)::text)
  • Filter: ((processed IS TRUE) AND (imported_transaction_id IS NOT NULL))
  • Rows Removed by Filter: 1
9.          

CTE seznam_id

10. 0.001 0.001 ↓ 0.0 0 1

Nested Loop (cost=0.56..2,320.60 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

11. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on duplicity_nezpracovane dn (cost=0.00..15.48 rows=774 width=146) (actual time=0.000..0.000 rows=0 loops=1)

12. 0.000 0.000 ↓ 0.0 0

Index Scan using index_raw_pabk_bank_tx_id on raw_pabk_transaction t (cost=0.56..2.97 rows=1 width=20) (never executed)

  • Index Cond: ((bank_tx_id)::text = (dn.bank_tx_id)::text)
  • Filter: ((processed IS FALSE) AND (imported_transaction_id IS NULL))
13. 0.003 88.488 ↑ 1.0 1 1

Aggregate (cost=17.41..17.43 rows=1 width=8) (actual time=88.488..88.488 rows=1 loops=1)

14. 88.485 88.485 ↓ 0.0 0 1

CTE Scan on duplicity_nezpracovane (cost=0.00..15.48 rows=774 width=0) (actual time=88.485..88.485 rows=0 loops=1)

15. 0.001 0.003 ↑ 1.0 1 1

Aggregate (cost=0.02..0.03 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1)

16. 0.002 0.002 ↓ 0.0 0 1

CTE Scan on seznam_id (cost=0.00..0.02 rows=1 width=0) (actual time=0.002..0.002 rows=0 loops=1)