explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 58Mf

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 9.604 ↑ 1.0 100 1

Limit (cost=217.97..22,135.09 rows=100 width=178) (actual time=1.308..9.604 rows=100 loops=1)

  • Buffers: shared hit=7415 read=131 written=5
2. 0.206 9.567 ↑ 2,979.9 100 1

Nested Loop (cost=217.97..65,311,699.33 rows=297,993 width=178) (actual time=1.308..9.567 rows=100 loops=1)

  • Buffers: shared hit=7415 read=131 written=5
3. 0.461 0.461 ↑ 2,979.9 100 1

Index Scan using requests_nk on requests r (cost=0.57..518,953.08 rows=297,993 width=114) (actual time=0.081..0.461 rows=100 loops=1)

  • Index Cond: ((owner_pacs_id = 465) AND (owner_server_id = 11) AND (owner_app_id = 1) AND (scoped_seq_num > 120))
  • Buffers: shared hit=16 read=26 written=2
4. 1.800 8.900 ↑ 1.0 1 100

Aggregate (cost=217.40..217.41 rows=1 width=17) (actual time=0.089..0.089 rows=1 loops=100)

  • Buffers: shared hit=7399 read=105 written=3
5. 7.000 7.100 ↑ 42.0 7 100

Append (cost=0.12..215.93 rows=294 width=17) (actual time=0.009..0.071 rows=7 loops=100)

  • Buffers: shared hit=7399 read=105 written=3
  • -> Index Scan using request_attrs_pk on request_attrs_partition_65720713 (cost=0.57..10.01 rows=82 width=16) (actual time=0.008..0.010 rows=7 loops
  • -> Index Scan using request_attrs_partition_current_request_id_idx on request_attrs_partition_69784592 (cost=0.44..8.60 rows=9 width=17) (actual ti
  • -> Index Scan using request_attrs_partition_current_request_id_idx1 on request_attrs_partition_73757112 (cost=0.44..8.60 rows=9 width=17) (actual t
  • -> Index Scan using request_attrs_partition_current_request_id_idx2 on request_attrs_partition_78026313 (cost=0.44..8.60 rows=9 width=18) (actual t
  • -> Index Scan using request_attrs_partition_current_request_id_idx3 on request_attrs_partition_82427763 (cost=0.44..8.60 rows=9 width=17) (actual t
  • -> Index Scan using request_attrs_partition_current_request_id_idx4 on request_attrs_partition_86598909 (cost=0.44..8.60 rows=9 width=17) (actual t
  • -> Index Scan using request_attrs_partition_current_request_id_idx5 on request_attrs_partition_91259051 (cost=0.44..8.58 rows=8 width=18) (actual t
  • -> Index Scan using request_attrs_partition_current_request_id_idx6 on request_attrs_partition_95482803 (cost=0.44..8.60 rows=9 width=17) (actual t
  • -> Index Scan using request_attrs_partition_current_request_id_idx7 on request_attrs_partition_100065338 (cost=0.44..8.58 rows=8 width=18) (actual
  • -> Index Scan using request_attrs_partition_current_request_id_idx8 on request_attrs_partition_104279488 (cost=0.44..8.60 rows=9 width=18) (actual
  • -> Index Scan using request_attrs_partition_current_request_id_idx9 on request_attrs_partition_108708377 (cost=0.44..8.58 rows=8 width=18) (actual
  • -> Index Scan using request_attrs_partition_current_request_id_idx10 on request_attrs_partition_113329891 (cost=0.44..8.58 rows=8 width=18) (actual
  • -> Index Scan using request_attrs_partition_current_request_id_idx11 on request_attrs_partition_117498746 (cost=0.44..8.60 rows=9 width=17) (actual
  • -> Index Scan using request_attrs_partition_current_request_id_idx12 on request_attrs_partition_121153192 (cost=0.44..8.61 rows=10 width=16) (actua
  • -> Index Scan using request_attrs_partition_current_request_id_idx13 on request_attrs_partition_124856537 (cost=0.44..8.61 rows=10 width=16) (actua
  • -> Index Scan using request_attrs_partition_current_request_id_idx14 on request_attrs_partition_128586456 (cost=0.44..8.61 rows=10 width=16) (actua
  • -> Index Scan using request_attrs_partition_current_request_id_idx15 on request_attrs_partition_132364891 (cost=0.44..8.60 rows=9 width=17) (actual
  • -> Index Scan using request_attrs_partition_current_request_id_idx16 on request_attrs_partition_136067999 (cost=0.44..8.60 rows=9 width=16) (actual
  • -> Index Scan using request_attrs_partition_current_request_id_idx17 on request_attrs_partition_140131901 (cost=0.44..8.60 rows=9 width=16) (actual
  • -> Index Scan using request_attrs_partition_current_request_id_idx18 on request_attrs_partition_143942358 (cost=0.44..8.61 rows=10 width=16) (actua
  • -> Index Scan using request_attrs_partition_current_request_id_idx19 on request_attrs_partition_147631484 (cost=0.44..8.61 rows=10 width=16) (actua
  • -> Index Scan using request_attrs_partition_current_request_id_idx20 on request_attrs_partition_151400024 (cost=0.44..8.61 rows=10 width=16) (actua
  • -> Index Scan using request_attrs_partition_current_request_id_idx21 on request_attrs_partition_155078469 (cost=0.44..8.61 rows=10 width=16) (actua
  • -> Index Scan using request_attrs_partition_current_request_id_idx22 on request_attrs_partition_current (cost=0.44..8.61 rows=10 width=16) (actual
6. 0.100 0.100 ↓ 0.0 0 100

Index Scan using request_attrs_request_id_idx on request_attrs (cost=0.12..8.14 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=100)

  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=100
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=468 read=36 written=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=297 read=3