explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KVsA

Settings
# exclusive inclusive rows x rows loops node
1. 375.658 52,435.633 ↑ 2.1 8,162 1

Hash Join (cost=231,226.86..266,006.51 rows=16,892 width=7) (actual time=51,792.550..52,435.633 rows=8,162 loops=1)

  • Hash Cond: (document_os_operations.basedocumentmodel_ptr_id = document_base.id)
2. 318.504 318.504 ↓ 1.0 1,948,409 1

Seq Scan on document_os_operations (cost=0.00..29,665.08 rows=1,948,408 width=4) (actual time=0.008..318.504 rows=1,948,409 loops=1)

3. 92.525 51,741.471 ↑ 2.8 80,973 1

Hash (cost=228,415.54..228,415.54 rows=224,905 width=11) (actual time=51,741.470..51,741.471 rows=80,973 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 5594kB
4. 51,648.946 51,648.946 ↑ 2.8 80,973 1

Index Scan using document_ba_ent_id_d11d50_idx on document_base (cost=0.56..228,415.54 rows=224,905 width=11) (actual time=1.741..51,648.946 rows=80,973 loops=1)

  • Index Cond: ((ent_id = ANY ('{3349,9556,7228,3407,3406,3393,3351,3352,3353,3369,3371,3364,3367,3370,3365,3366,3368,6733,3354,3355,3356,3357,3358,3359,3360,3361,3362,3363,3378,3379,3380,3392,3377,3381,3382,3383,3384,3385,3386,3372,3373,3374,33 (...)
  • Filter: ((document_storno_id IS NULL) AND (state <> 4) AND (number ~ '[0-9]+'::text))
  • Rows Removed by Filter: 1809
Planning time : 23.701 ms
Execution time : 52,436.747 ms