explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0oCi

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 42,448.172 ↓ 0.0 0 1

Sort (cost=407,164.62..407,169.50 rows=1,951 width=36) (actual time=42,448.171..42,448.172 rows=0 loops=1)

  • Output: n.id, n.event_time, n.name
  • Sort Key: n.event_time, n.name
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=17772 read=343960
2. 0.000 42,448.153 ↓ 0.0 0 1

Group (cost=406,545.16..407,058.00 rows=1,951 width=36) (actual time=42,448.153..42,448.153 rows=0 loops=1)

  • Output: n.id, n.event_time, n.name
  • Group Key: n.id
  • Buffers: shared hit=17772 read=343960
3. 7.352 42,448.289 ↓ 0.0 0 1

Gather Merge (cost=406,545.16..407,048.24 rows=3,902 width=36) (actual time=42,448.152..42,448.289 rows=0 loops=1)

  • Output: n.id, n.event_time, n.name
  • Workers Planned: 2
  • Workers Launched: 0
  • Buffers: shared hit=17772 read=343960
4. 0.003 42,440.937 ↓ 0.0 0 1

Group (cost=405,545.13..405,597.83 rows=1,951 width=36) (actual time=42,440.936..42,440.937 rows=0 loops=1)

  • Output: n.id, n.event_time, n.name
  • Group Key: n.id
  • Buffers: shared hit=17772 read=343960
5. 0.039 42,440.934 ↓ 0.0 0 1

Sort (cost=405,545.13..405,571.48 rows=10,540 width=36) (actual time=42,440.933..42,440.934 rows=0 loops=1)

  • Output: n.id, n.event_time, n.name
  • Sort Key: n.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=17772 read=343960
6. 4,258.605 42,440.895 ↓ 0.0 0 1

Hash Join (cost=13,405.13..404,840.87 rows=10,540 width=36) (actual time=42,440.895..42,440.895 rows=0 loops=1)

  • Output: n.id, n.event_time, n.name
  • Inner Unique: true
  • Hash Cond: (m.node_id = n.id)
  • Buffers: shared hit=17772 read=343960
7. 27,399.226 27,399.226 ↓ 2.4 4,128,293 1

Parallel Seq Scan on public.markets m (cost=0.00..386,921.60 rows=1,719,650 width=8) (actual time=0.022..27,399.226 rows=4,128,293 loops=1)

  • Output: m.id, m.name, m.sys_mrkt_name, m.disp_order, m.state, m.mrkt_type, m.node_id, m.prod_id, m.maar_id, m.syst_id, m.sys_ref, m.sys_mrkt_type, m.orig_mark_id, m.link_mark_id, m.auth_defb_id, m.alse_id, m.ref1, m.ref2, m.ref3, m.ref4, m.ref5, m.source, m.visible, m.published, m.bir, m.each_way_available, m.each_way_places, m.double_resulting, m.settled, m.result_confirmed, m.deleted, m.modified, m.oca, m.mpath, m.blurb, m.handicap, m.created, m.attributes, m.outright, m.algo_mrkt_key, m.last_bet_settled_time, m.prematch_event_result_state
  • Filter: (m.result_confirmed = '1'::numeric)
  • Rows Removed by Filter: 1644559
  • Buffers: shared hit=17228 read=339627
8. 0.918 10,783.064 ↑ 3.3 587 1

Hash (cost=13,380.74..13,380.74 rows=1,951 width=36) (actual time=10,783.064..10,783.064 rows=587 loops=1)

  • Output: n.id, n.event_time, n.name
  • Buckets: 2048 Batches: 1 Memory Usage: 65kB
  • Buffers: shared hit=544 read=4333
9. 288.032 10,782.146 ↑ 3.3 587 1

Bitmap Heap Scan on public.nodes n (cost=8,448.64..13,380.74 rows=1,951 width=36) (actual time=10,494.301..10,782.146 rows=587 loops=1)

  • Output: n.id, n.event_time, n.name
  • Recheck Cond: ((n.maar_id = 3) AND (n.event_time >= '2020-01-12 00:00:00+00'::timestamp with time zone) AND (n.event_time <= '2020-01-17 00:00:00+00'::timestamp with time zone) AND (n.syst_id = 1))
  • Filter: (((n.type)::text = 'TRADING'::text) AND ((n.state)::text = 'COMPLETED'::text))
  • Rows Removed by Filter: 179
  • Heap Blocks: exact=703
  • Buffers: shared hit=544 read=4333
10. 1.076 10,494.114 ↓ 0.0 0 1

BitmapAnd (cost=8,448.64..8,448.64 rows=2,954 width=0) (actual time=10,494.114..10,494.114 rows=0 loops=1)

  • Buffers: shared hit=8 read=4166
11. 3,690.183 3,690.183 ↓ 1.1 34,846 1

Bitmap Index Scan on nodes_maar_id_fkey_idx (cost=0.00..2,934.47 rows=32,807 width=0) (actual time=3,690.183..3,690.183 rows=34,846 loops=1)

  • Index Cond: (n.maar_id = 3)
  • Buffers: shared hit=6 read=1719
12. 6,802.855 6,802.855 ↓ 1.1 32,787 1

Bitmap Index Scan on nodes_event_time_syst_id_deleted_idx (cost=0.00..5,512.93 rows=28,661 width=0) (actual time=6,802.854..6,802.855 rows=32,787 loops=1)

  • Index Cond: ((n.event_time >= '2020-01-12 00:00:00+00'::timestamp with time zone) AND (n.event_time <= '2020-01-17 00:00:00+00'::timestamp with time zone) AND (n.syst_id = 1))
  • Buffers: shared hit=2 read=2447