explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gV7M

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 0.217 ↑ 345.0 1 1

GroupAggregate (cost=86.19..16,581.46 rows=345 width=57) (actual time=0.217..0.217 rows=1 loops=1)

  • Group Key: calendar_items.series_id
2. 0.012 0.195 ↑ 4.9 70 1

Nested Loop (cost=86.19..16,575.42 rows=345 width=76) (actual time=0.037..0.195 rows=70 loops=1)

3. 0.019 0.043 ↑ 12.7 70 1

Bitmap Heap Scan on calendar_items (cost=85.62..8,932.24 rows=889 width=29) (actual time=0.029..0.043 rows=70 loops=1)

  • Recheck Cond: (series_id = '3f9p85g1valifgo3ikto8rvgg5_R20200728T183000'::text)
  • Filter: (deleted IS FALSE)
  • Heap Blocks: exact=5
4. 0.024 0.024 ↑ 32.1 70 1

Bitmap Index Scan on index_calendar_items_on_series_id (cost=0.00..85.40 rows=2,244 width=0) (actual time=0.024..0.024 rows=70 loops=1)

  • Index Cond: (series_id = '3f9p85g1valifgo3ikto8rvgg5_R20200728T183000'::text)
5. 0.140 0.140 ↑ 1.0 1 70

Index Scan using index_external_id_on_owner_id_and_external_system on external_id (cost=0.57..8.59 rows=1 width=55) (actual time=0.002..0.002 rows=1 loops=70)

  • Index Cond: (owner_id = calendar_items.id)
  • Filter: ((deleted IS FALSE) AND ((owner_type)::text = 'calendar_item'::text))