explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AOu6

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 38.339 ↑ 1.0 100 1

Limit (cost=0.42..19,060.10 rows=100 width=36) (actual time=0.938..38.339 rows=100 loops=1)

2. 1.603 38.303 ↑ 1,043.0 100 1

Index Scan Backward using pk_translations on translations t (cost=0.42..19,878,666.27 rows=104,297 width=36) (actual time=0.937..38.303 rows=100 loops=1)

  • Filter: ((locale_code)::text = 'en_GB'::text)
  • Rows Removed by Filter: 858
3.          

SubPlan (for Index Scan Backward)

4. 0.100 36.700 ↓ 0.0 0 100

Limit (cost=189.69..189.69 rows=1 width=36) (actual time=0.367..0.367 rows=0 loops=100)

5. 0.500 36.600 ↓ 0.0 0 100

Sort (cost=189.69..189.69 rows=1 width=36) (actual time=0.366..0.366 rows=0 loops=100)

  • Sort Key: tn.id DESC
  • Sort Method: quicksort Memory: 25kB
6. 36.100 36.100 ↓ 0.0 0 100

Seq Scan on translation_notes tn (cost=0.00..189.68 rows=1 width=36) (actual time=0.361..0.361 rows=0 loops=100)

  • Filter: ((translation_key_id = t.translation_key_id) AND ((locale_code)::text = (t.locale_code)::text) AND ((details -> 'translation_vendor'::text) ? 'vendor_batch_id'::text) AND ((details #>> '{translation_vendor,vendor_name}'::text[]) = 'lingotek'::text))
  • Rows Removed by Filter: 1284
Planning time : 0.730 ms