explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rvGs

Settings
# exclusive inclusive rows x rows loops node
1. 2,275.460 8,265.441 ↓ 1.0 1,809,525 1

Hash Join (cost=105,039.22..351,121.84 rows=1,793,358 width=206) (actual time=1,348.343..8,265.441 rows=1,809,525 loops=1)

  • Hash Cond: (iplc_case.id = positive_case_tags.case_id)
2. 4,644.942 4,644.942 ↓ 1.0 2,817,165 1

Seq Scan on iplc_case (cost=0.00..200,030.02 rows=2,811,902 width=206) (actual time=0.093..4,644.942 rows=2,817,165 loops=1)

3. 646.722 1,345.039 ↓ 1.0 1,809,525 1

Hash (cost=82,622.25..82,622.25 rows=1,793,358 width=4) (actual time=1,345.039..1,345.039 rows=1,809,525 loops=1)

  • Buckets: 2,097,152 Batches: 1 Memory Usage: 80,001kB
4. 154.236 698.317 ↓ 1.0 1,809,525 1

Append (cost=0.00..82,622.25 rows=1,793,358 width=4) (actual time=0.107..698.317 rows=1,809,525 loops=1)

5. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on positive_case_tags (cost=0.00..0.00 rows=1 width=4) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (tag_id = ANY ('{22,27,24,23,263,432,36,286,89,386,287,370,451,452,449,486}'::integer[]))
6. 544.073 544.073 ↓ 1.0 1,809,525 1

Index Only Scan using ix_positve_case_tags_released_20200319143044 on positve_case_tags (cost=0.43..73,655.46 rows=1,793,357 width=4) (actual time=0.097..544.073 rows=1,809,525 loops=1)

  • Heap Fetches: 318,073
Planning time : 3.707 ms
Execution time : 8,349.155 ms