explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Laiz

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

Update on history_data (cost=7,561.40..2,753,731.95 rows=1,510,622 width=28) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=7,561.40..2,753,731.95 rows=1,510,622 width=28) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on history_tags (cost=0.00..27.91 rows=4 width=10) (actual rows= loops=)

  • Filter: (group_id = 14)
4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on history_data (cost=7,561.40..684,649.45 rows=377,656 width=18) (actual rows= loops=)

  • Recheck Cond: (tag_id = history_tags.tag_id)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on history_data_tag_id_time_id_idx (cost=0.00..7,466.99 rows=377,656 width=0) (actual rows= loops=)

  • Index Cond: (tag_id = history_tags.tag_id)