explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bwc3 : 1

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↑ 1.0 5 1

Subquery Scan on data (cost=319,325.51..319,326.16 rows=5 width=32) (actual rows=5 loops=1)

  • Buffers: shared hit=102 read=27,827 dirtied=3
2. 0.000 0.000 ↑ 1.0 5 1

Limit (cost=319,325.51..319,326.09 rows=5 width=1,094) (actual rows=5 loops=1)

  • Buffers: shared hit=102 read=27,827 dirtied=3
3. 0.000 0.000 ↑ 10,334.0 5 1

Gather Merge (cost=319,325.51..325,354.10 rows=51,670 width=1,094) (actual rows=5 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=102 read=27,827 dirtied=3
4. 0.000 0.000 ↑ 5,167.0 5 3 / 3

Sort (cost=318,325.49..318,390.07 rows=25,835 width=1,094) (actual rows=5 loops=3)

  • Sort Key: transaction_view.stmtdate DESC
  • Sort Method: top-N heapsort Memory: 33kB
  • Worker 0: Sort Method: top-N heapsort Memory: 32kB
  • Worker 1: Sort Method: top-N heapsort Memory: 31kB
  • Buffers: shared hit=102 read=27,827 dirtied=3
5. 0.000 0.000 ↑ 1.0 24,936 3 / 3

Parallel Bitmap Heap Scan on transaction_view (cost=4,137.03..317,896.38 rows=25,835 width=1,094) (actual rows=24,936 loops=3)

  • Recheck Cond: ((accountkey)::text = ANY ('{40702978400001400894:400,894,40702978100000400894:400,894,40702840800001400894:400,894,40702840500000400894:400,894,40702810700000046020:400,894,40702810600000056424:400,894,40702810500001400894:400,894}'::text[]))
  • Filter: drcr
  • Rows Removed by Filter: 13,414
  • Heap Blocks: exact=9,386
  • Buffers: shared hit=88 read=27,827 dirtied=3
6. 0.000 0.000 ↑ 1.4 116,271 1 / 3

Bitmap Index Scan on idx_transaction_view_accountkey_operdate (cost=0.00..4,121.53 rows=158,754 width=0) (actual rows=116,271 loops=1)

  • Index Cond: ((accountkey)::text = ANY ('{40702978400001400894:400,894,40702978100000400894:400,894,40702840800001400894:400,894,40702840500000400894:400,894,40702810700000046020:400,894,40702810600000056424:400,894,40702810500001400894:400,894}'::text[]))
  • Buffers: shared hit=19 read=911