explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HIi4

Settings
# exclusive inclusive rows x rows loops node
1. 1,201.886 1,873,572.524 ↓ 9.8 4,965,752 1

Gather (cost=94,882.02..2,491,537.05 rows=507,650 width=8) (actual time=65,079.920..1,873,572.524 rows=4,965,752 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 374,283.957 1,872,370.638 ↓ 7.8 1,655,251 3

Nested Loop Semi Join (cost=93,882.02..2,439,772.05 rows=211,521 width=8) (actual time=64,828.045..1,872,370.638 rows=1,655,251 loops=3)

3. 1,421,472.382 1,498,086.456 ↓ 7.8 1,655,251 3

Nested Loop Semi Join (cost=93,881.45..2,223,749.29 rows=211,521 width=16) (actual time=64,827.985..1,498,086.456 rows=1,655,251 loops=3)

4. 11,642.855 76,613.295 ↓ 1.1 1,820,337 3

Parallel Bitmap Heap Scan on alf_node node (cost=93,880.88..539,672.35 rows=1,685,174 width=8) (actual time=64,784.371..76,613.295 rows=1,820,337 loops=3)

  • Recheck Cond: ((type_qname_id = ANY ('{191,523,53,330,240,227,470,146,482,249,246,444,467,248,392,454,434,247}'::bigint[])) AND (store_id = 6))
  • Rows Removed by Index Recheck: 2173195
  • Filter: (transaction_id > '-1'::integer)
  • Heap Blocks: exact=37927 lossy=87747
5. 64,970.440 64,970.440 ↓ 1.5 6,203,944 1

Bitmap Index Scan on idx_alf_node_tqn (cost=0.00..92,869.78 rows=4,044,688 width=0) (actual time=64,970.440..64,970.440 rows=6,203,944 loops=1)

  • Index Cond: ((type_qname_id = ANY ('{191,523,53,330,240,227,470,146,482,249,246,444,467,248,392,454,434,247}'::bigint[])) AND (store_id = 6))
6. 0.779 0.779 ↑ 7.0 1 5,461,012

Index Only Scan using alf_node_aspects_pkey on alf_node_aspects aspect_1 (cost=0.57..3.30 rows=7 width=8) (actual time=0.779..0.779 rows=1 loops=5,461,012)

  • Index Cond: ((node_id = node.id) AND (qname_id = ANY ('{252,324}'::bigint[])))
  • Heap Fetches: 99934
7. 0.225 0.225 ↑ 7.0 1 4,965,752

Index Only Scan using alf_node_aspects_pkey on alf_node_aspects aspect (cost=0.57..3.43 rows=7 width=8) (actual time=0.225..0.225 rows=1 loops=4,965,752)

  • Index Cond: (node_id = node.id)
  • Filter: (qname_id = ANY ('{524,254,325}'::bigint[]))
  • Rows Removed by Filter: 10
  • Heap Fetches: 1325802