explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ipHb

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

Limit (cost=8,881,849.52..8,881,849.77 rows=100 width=287) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=8,881,849.52..8,889,435.92 rows=3,034,557 width=287) (actual rows= loops=)

  • Sort Key: t.search_groupname, t.pivvot_subtype_cd, t.search_type
3. 0.000 0.000 ↓ 0.0

Append (cost=0.00..8,765,870.94 rows=3,034,557 width=287) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on aquifer t (cost=0.00..2,270.23 rows=2 width=206) (actual rows= loops=)

  • Filter: (search_tsvector @@ plainto_tsquery('%2014%'::text))
5. 0.000 0.000 ↓ 0.0

Seq Scan on bedrock t_1 (cost=0.00..62,821.84 rows=78,487 width=89) (actual rows= loops=)

  • Filter: (search_tsvector @@ plainto_tsquery('%2014%'::text))
6. 0.000 0.000 ↓ 0.0

Seq Scan on cnw t_2 (cost=0.00..2,427.60 rows=3 width=236) (actual rows= loops=)

  • Filter: (search_tsvector @@ plainto_tsquery('%2014%'::text))
7. 0.000 0.000 ↓ 0.0

Seq Scan on structuresandinfrastructure t_3 (cost=0.00..7,617,323.40 rows=2,920,928 width=292) (actual rows= loops=)

  • Filter: (search_tsvector @@ plainto_tsquery('%2014%'::text))
8. 0.000 0.000 ↓ 0.0

Seq Scan on landownership t_4 (cost=0.00..375,552.91 rows=34,308 width=267) (actual rows= loops=)

  • Filter: (search_tsvector @@ plainto_tsquery('%2014%'::text))
9. 0.000 0.000 ↓ 0.0

Seq Scan on existingpipelines t_5 (cost=0.00..705,474.96 rows=829 width=278) (actual rows= loops=)

  • Filter: (search_tsvector @@ plainto_tsquery('%2014%'::text))