explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ofY4

Settings
# exclusive inclusive rows x rows loops node
1. 0.042 43.141 ↑ 1.0 100 1

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

  • Buffers: shared hit=7440 read=106 written=22
2. 0.204 43.099 ↑ 2,979.9 100 1

Nested Loop (cost=217.97..65,311,037.71 rows=297,990 width=178) (actual time=6.079..43.099 rows=100 loops=1)

  • Buffers: shared hit=7440 read=106 written=22
3. 0.495 0.495 ↑ 2,979.9 100 1

Index Scan using requests_nk on requests r (cost=0.57..518,943.76 rows=297,990 width=114) (actual time=0.125..0.495 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=17 read=25 written=6
4. 1.200 42.400 ↑ 1.0 1 100

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

  • Buffers: shared hit=7423 read=81 written=16
5. 41.100 41.200 ↑ 42.0 7 100

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

  • Buffers: shared hit=7423 read=81 written=16
  • -> Index Scan using request_attrs_pk on request_attrs_partition_65720713 (cost=0.57..10.01 rows=82 width=16) (actual time=0.344..0.348 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=469 read=35 written=4
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2 written=1
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2 written=1
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2 written=1
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2 written=1
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2 written=1
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2 written=1
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2 written=1
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2 written=1
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2 written=1
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2 written=1
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2 written=2
  • Index Cond: (request_id = r.request_id)
  • Buffers: shared hit=298 read=2