explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FMVx

Settings
# exclusive inclusive rows x rows loops node
1. 0.102 30.540 ↑ 1.0 722 1

Limit (cost=1,002.86..103,543.79 rows=722 width=287) (actual time=4.859..30.540 rows=722 loops=1)

  • Buffers: shared hit=21,334 read=9
2. 12.236 30.438 ↑ 11.3 722 1

Gather Merge (cost=1,002.86..1,163,890.90 rows=8,188 width=287) (actual time=4.858..30.438 rows=722 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=21,334 read=9
3. 0.169 18.202 ↑ 13.4 254 3 / 3

Nested Loop Left Join (cost=2.83..1,161,945.77 rows=3,412 width=287) (actual time=0.188..18.202 rows=254 loops=3)

  • Buffers: shared hit=21,334 read=9
4. 0.266 15.744 ↑ 13.4 254 3 / 3

Nested Loop Left Join (cost=2.41..1,160,020.93 rows=3,412 width=230) (actual time=0.158..15.744 rows=254 loops=3)

  • Buffers: shared hit=18,303 read=9
5. 0.214 12.935 ↑ 13.4 254 3 / 3

Nested Loop Left Join (cost=1.98..1,156,994.71 rows=3,412 width=235) (actual time=0.131..12.935 rows=254 loops=3)

  • Buffers: shared hit=15,271 read=9
6. 0.165 10.438 ↑ 13.4 254 3 / 3

Nested Loop (cost=1.55..1,154,473.39 rows=3,412 width=208) (actual time=0.105..10.438 rows=254 loops=3)

  • Buffers: shared hit=12,221 read=9
7. 0.056 7.736 ↑ 13.5 254 3 / 3

Nested Loop (cost=1.12..1,152,226.19 rows=3,418 width=141) (actual time=0.079..7.736 rows=254 loops=3)

  • Buffers: shared hit=9,172 read=9
8. 5.321 6.788 ↑ 1,350.9 892 3 / 3

Nested Loop (cost=0.98..850,451.24 rows=1,205,010 width=138) (actual time=0.057..6.788 rows=892 loops=3)

  • Buffers: shared hit=5,734 read=9
  • -> Index Only Scan using rel_group_store_store_id_group_id_idx on rel_group_store rel (cost=0.56..1.03 rows=3 width=32) (actual time=0.015..0.020 rows=4 loop
9. 1.467 1.467 ↑ 1,695.3 254 3 / 3

Parallel Index Scan using idx_store_name on merchant_stores store (cost=0.43..277,073.29 rows=430,602 width=106) (actual time=0.015..1.467 rows=254 loops=3)

  • Filter: enabled
  • Rows Removed by Filter: 86
  • Buffers: shared hit=1,136
  • Index Cond: (store_id = store.id)
  • Heap Fetches: 595
  • Buffers: shared hit=4,598 read=9
10. 0.892 0.892 ↓ 0.0 0 2,675 / 3

Index Scan using group_id_idx on "group" gp (cost=0.14..0.25 rows=1 width=35) (actual time=0.001..0.001 rows=0 loops=2,675)

  • Index Cond: (id = rel.group_id)
  • Buffers: shared hit=3,438
11. 2.537 2.537 ↑ 1.0 1 761 / 3

Index Scan using merchant_address_pkey on merchant_addresses address (cost=0.43..0.66 rows=1 width=99) (actual time=0.010..0.010 rows=1 loops=761)

  • Index Cond: (id = store.id)
  • Buffers: shared hit=3,049
12. 2.283 2.283 ↑ 1.0 1 761 / 3

Index Scan using merchant_contacts_merchant_id_idx1 on merchant_contacts ct (cost=0.43..0.64 rows=1 width=43) (actual time=0.009..0.009 rows=1 loops=761)

  • Index Cond: (merchant_id = store.id)
  • Buffers: shared hit=3,050
13. 2.543 2.543 ↑ 1.0 1 763 / 3

Index Scan using merchant_phones_contact_id_index on merchant_phones phone (cost=0.43..0.79 rows=1 width=27) (actual time=0.010..0.010 rows=1 loops=763)

  • Index Cond: (ct.id = contact_id)
  • Buffers: shared hit=3,032
14. 2.289 2.289 ↑ 1.0 1 763 / 3

Index Scan using merchant_resources_merchant_id_idx on merchant_resources resource (cost=0.42..0.56 rows=1 width=73) (actual time=0.009..0.009 rows=1 loops=763)

  • Index Cond: (merchant_id = store.id)
  • Buffers: shared hit=3,031
Planning time : 3.651 ms
Execution time : 30.675 ms