explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TCAg

Settings
# exclusive inclusive rows x rows loops node
1. 12.821 23,109.035 ↑ 1.1 72,852 1

Gather Merge (cost=90,144.13..99,311.97 rows=76,568 width=229) (actual time=23,081.210..23,109.035 rows=72,852 loops=1)

  • Workers Planned: 4
  • Workers Launched: 0
  • Buffers: shared hit=7 read=58,038
  • I/O Timings: read=3,218.967
2. 333.439 23,096.214 ↓ 3.8 72,852 1

Sort (cost=89,144.07..89,191.92 rows=19,142 width=229) (actual time=23,079.697..23,096.214 rows=72,852 loops=1)

  • Sort Key: txdetails.account_type_id, accounts.full_qualified_name, txdetails.txn_date
  • Sort Method: quicksort Memory: 17,380kB
  • Buffers: shared hit=7 read=58,038
  • I/O Timings: read=3,218.967
3. 95.697 22,762.775 ↓ 3.8 72,852 1

Hash Semi Join (cost=1,550.28..87,782.64 rows=19,142 width=229) (actual time=3,371.727..22,762.775 rows=72,852 loops=1)

  • Hash Cond: ((txdetails.txn_type_id)::numeric = (((unnest('{1,3,4,7,8,9,11,12,13,14,15,20,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64}'::text[])))::numeric))
  • Buffers: shared hit=7 read=58,038
  • I/O Timings: read=3,218.967
4. 29.542 22,667.045 ↓ 1.9 72,852 1

Parallel Hash Join (cost=1,545.76..87,246.93 rows=38,285 width=169) (actual time=3,371.674..22,667.045 rows=72,852 loops=1)

  • Hash Cond: (txdetails.account_id = accounts.account_id)
  • Buffers: shared hit=7 read=58,038
  • I/O Timings: read=3,218.967
5. 8.649 22,486.137 ↓ 3.4 72,852 1

Parallel Append (cost=1,173.77..86,041.55 rows=21,152 width=156) (actual time=3,220.168..22,486.137 rows=72,852 loops=1)

  • Buffers: shared hit=6 read=57,753
  • I/O Timings: read=3,144.227
6. 19,294.992 22,477.488 ↓ 3.4 72,852 1

Parallel Bitmap Heap Scan on transaction_detail_p27 txdetails (cost=1,173.77..85,935.79 rows=21,152 width=156) (actual time=3,220.167..22,477.488 rows=72,852 loops=1)

  • Recheck Cond: (company_id = '9130346625745886'::numeric)
  • Filter: (is_non_posting IS NULL)
  • Rows Removed by Filter: 15,155
  • Heap Blocks: exact=60,827
  • Buffers: shared hit=6 read=57,753
  • I/O Timings: read=3,144.227
7. 3,182.496 3,182.496 ↑ 1.0 88,007 1

Bitmap Index Scan on txnd_cid_tdate_aid_cid_i2_p27 (cost=0.00..1,152.62 rows=88,007 width=0) (actual time=3,182.496..3,182.496 rows=88,007 loops=1)

  • Index Cond: (company_id = '9130346625745886'::numeric)
  • Buffers: shared hit=1 read=496
  • I/O Timings: read=3,144.227
8. 0.155 151.366 ↓ 1.4 290 1

Parallel Hash (cost=369.33..369.33 rows=213 width=38) (actual time=151.365..151.366 rows=290 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 40kB
  • Buffers: shared hit=1 read=285
  • I/O Timings: read=74.740
9. 0.039 151.211 ↓ 1.4 290 1

Parallel Append (cost=0.43..369.33 rows=213 width=38) (actual time=8.645..151.211 rows=290 loops=1)

  • Buffers: shared hit=1 read=285
  • I/O Timings: read=74.740
10. 151.172 151.172 ↓ 1.4 290 1

Parallel Index Scan using account_p11_pkey on account_p11 accounts (cost=0.43..368.27 rows=213 width=38) (actual time=8.644..151.172 rows=290 loops=1)

  • Index Cond: (company_id = '9130346625745886'::numeric)
  • Buffers: shared hit=1 read=285
  • I/O Timings: read=74.740
11. 0.009 0.033 ↑ 1.9 52 1

Hash (cost=3.27..3.27 rows=100 width=32) (actual time=0.032..0.033 rows=52 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
12. 0.015 0.024 ↑ 1.9 52 1

Result (cost=0.00..2.27 rows=100 width=32) (actual time=0.007..0.024 rows=52 loops=1)

13. 0.008 0.009 ↑ 1.9 52 1

ProjectSet (cost=0.00..0.52 rows=100 width=32) (actual time=0.004..0.009 rows=52 loops=1)

14. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)