explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3ruG

Settings
# exclusive inclusive rows x rows loops node
1. 16.698 495.574 ↓ 1.8 84,177 1

Gather (cost=2,404.75..158,667.58 rows=45,579 width=234) (actual time=47.171..495.574 rows=84,177 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 27.410 478.876 ↓ 1.5 28,059 3 / 3

Nested Loop (cost=1,404.75..153,109.68 rows=18,991 width=234) (actual time=42.969..478.876 rows=28,059 loops=3)

3. 3.936 81.378 ↓ 3.9 52,870 3 / 3

Parallel Append (cost=1,404.18..56,390.40 rows=13,412 width=81) (actual time=42.906..81.378 rows=52,870 loops=3)

4. 62.796 77.442 ↓ 3.9 52,870 3 / 3

Parallel Bitmap Heap Scan on txdetails_p6 txdetails (cost=1,404.18..56,323.34 rows=13,412 width=81) (actual time=42.906..77.442 rows=52,870 loops=3)

  • Recheck Cond: ((company_id = 178348139.000000000) AND (tx_date >= '2019-08-01'::date) AND (tx_date < '2019-12-31'::date) AND (is_no_post IS NULL))
  • Filter: (((tx_type_id = '8'::numeric) AND (sequence >= '0'::numeric)) OR ((tx_type_id <> '8'::numeric) AND (sequence > '0'::numeric)))
  • Rows Removed by Filter: 11436
  • Heap Blocks: exact=5147
5. 14.646 14.646 ↓ 3.9 192,918 1 / 3

Bitmap Index Scan on txdetails_p6_company_id_date_tx_date_is_no_post_tx_id_seque_idx (cost=0.00..1,396.13 rows=49,675 width=0) (actual time=43.937..43.937 rows=192,918 loops=1)

  • Index Cond: ((company_id = 178348139.000000000) AND (tx_date >= '2019-08-01'::date) AND (tx_date < '2019-12-31'::date) AND (is_no_post IS NULL))
6. 0.000 370.088 ↑ 1.0 1 158,609 / 3

Append (cost=0.57..7.18 rows=1 width=79) (actual time=0.007..0.007 rows=1 loops=158,609)

7. 370.088 370.088 ↑ 1.0 1 158,609 / 3

Index Scan using transactionheaders_p6_pkey on transactionheaders_p6 txheaders (cost=0.57..7.18 rows=1 width=79) (actual time=0.007..0.007 rows=1 loops=158,609)

  • Index Cond: ((company_id = 178348139.000000000) AND (tx_id = txdetails.tx_id))
  • Filter: (tx_type_id = ANY ('{7,4,32}'::numeric[]))
  • Rows Removed by Filter: 0
Planning time : 19.285 ms
Execution time : 499.157 ms