explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ODi0

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=27,952,393.38..30,395,466.53 rows=100 width=175) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=27,952,393.38..35,696,935.28 rows=317 width=175) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=27,951,393.38..35,695,903.58 rows=132 width=175) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=27,951,393.08..35,695,101.77 rows=132 width=183) (actual rows= loops=)

  • Hash Cond: ((iag.fk_items = it.pk_items) AND (iag.firstname = iai.firstname) AND (iag.lastname = iai.lastname))
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,341.60..2,889,975.26 rows=2,819,601 width=35) (actual rows= loops=)

  • Hash Cond: (iag.grid_id = add.grid_id)
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on items_authors_grid iag (cost=0.00..2,602,968.20 rows=68,658,520 width=35) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=1,291.91..1,291.91 rows=3,975 width=13) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on addresses add (cost=87.22..1,291.91 rows=3,975 width=13) (actual rows= loops=)

  • Recheck Cond: (country = 'Germany'::text)
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "IDX_addresses_country" (cost=0.00..86.23 rows=3,975 width=0) (actual rows= loops=)

  • Index Cond: (country = 'Germany'::text)
10. 0.000 0.000 ↓ 0.0

Hash (cost=22,234,380.46..22,234,380.46 rows=133,261,544 width=178) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash Join (cost=5,476,950.62..22,234,380.46 rows=133,261,544 width=178) (actual rows= loops=)

  • Hash Cond: (iai.fk_items = it.pk_items)
12. 0.000 0.000 ↓ 0.0

Seq Scan on items_authors_institutions iai (cost=0.00..7,235,893.36 rows=224,416,936 width=122) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash (cost=4,098,764.10..4,098,764.10 rows=61,897,482 width=56) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on items it (cost=0.00..4,098,764.10 rows=61,897,482 width=56) (actual rows= loops=)

  • Filter: (pubyear >= 2000)
15. 0.000 0.000 ↓ 0.0

Index Only Scan using "IDX_sources_pksources" on sources sou (cost=0.29..6.07 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (pk_sources = it.fk_sources)