explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QCWo

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 6,513.102 ↑ 1.0 1 1

Limit (cost=0.00..14,073.98 rows=1 width=16) (actual time=6,513.101..6,513.102 rows=1 loops=1)

2. 0.003 6,513.100 ↑ 784,432.0 1 1

Group (cost=0.00..11,040,083,577.12 rows=784,432 width=16) (actual time=6,513.100..6,513.100 rows=1 loops=1)

3. 5,787.693 6,513.097 ↑ 2,451,835,938.0 1 1

Nested Loop (cost=0.00..11,033,953,987.28 rows=2,451,835,938 width=16) (actual time=6,513.097..6,513.097 rows=1 loops=1)

  • Join Filter: (((m.mapping_id)::character varying)::text = split_part(fd.allowed_value, ','::text, 1))
4. 0.096 0.862 ↑ 63,657.3 39 1

Nested Loop (cost=0.00..620,652.16 rows=2,482,633 width=32) (actual time=0.009..0.862 rows=39 loops=1)

5. 0.136 0.136 ↑ 37,353.9 21 1

Index Scan using pk_hotel_ on hotel h (cost=0.00..129,568.78 rows=784,432 width=16) (actual time=0.003..0.136 rows=21 loops=1)

6. 0.630 0.630 ↑ 1.5 2 21

Index Scan using idx_clusterid_20121011 on mapping_element m (cost=0.00..0.59 rows=3 width=32) (actual time=0.011..0.030 rows=2 loops=21)

  • Index Cond: (cluster_id = h.cluster_id)
7. 364.268 724.542 ↑ 1.1 187,260 39

Materialize (cost=0.00..72,109.56 rows=197,519 width=8) (actual time=0.011..18.578 rows=187,260 loops=39)

8. 360.274 360.274 ↑ 1.0 191,953 1

Seq Scan on filter_definition fd (cost=0.00..71,121.96 rows=197,519 width=8) (actual time=0.422..360.274 rows=191,953 loops=1)

  • Filter: ((filter_aspect)::text = 'MAPPING'::text)"Total runtime: 6519.590 ms